package org.jeecg.modules.flow.temp.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

/*
 * 项目名称:    wms-server-jeecg
 * 接口描述:    //
 * 创建人员:    zhaojun
 * 创建时间:    2023-12-02
 */
@Data
public class MaterialTaskExcel implements Serializable {

    private static final long serialVersionUID = 1L;
    @Excel(name = "钢卷号", width = 15)
    @ApiModelProperty(value = "钢卷号")
    public String steelCoilNumber;
    /**
     * 公司代码
     */
    @Excel(name = "公司代码", width = 15)
    @ApiModelProperty(value = "公司代码")
    private String sysOrgCode;
    /**
     * 物料id
     */
    @Excel(name = "物料", width = 15)
    @ApiModelProperty(value = "物料id")
    private String wmsBasicMaterialId;
    /**
     * 批次号      1
     */
    @Excel(name = "批次", width = 15)
    @ApiModelProperty(value = "批次")
    private String batchCode;
    /**
     * 订单库存数     1
     */
    @Excel(name = "订单库存数", width = 15)
    @ApiModelProperty(value = "订单库存数")
    private BigDecimal planQuantity;
    /**
     * 库存单位
     */
    @Excel(name = "库存单位", width = 15, dictTable = "wms_basic_unit", dicText = "name", dicCode = "id")
    @ApiModelProperty(value = "库存单位")
    private String wmsBasicUnitId;
    /**
     * 库位   1
     */
    @Excel(name = "库位", width = 15)
    @ApiModelProperty(value = "库位")
    private String storeCode;
    /**
     * 辅数量
     */
    @Excel(name = "辅数量", width = 15)
    @ApiModelProperty(value = "辅数量")
    private BigDecimal assistQuantity;
    /**
     * 实测净重    1
     */
    @Excel(name = "净重", width = 15)
    @ApiModelProperty(value = "净重")
    private BigDecimal measuredWeight;
    /**
     * 毛重
     */
    @Excel(name = "毛重", width = 15)
    @ApiModelProperty(value = "毛重")
    private BigDecimal grossWeight;
    /**
     * 入库日期   1
     */
    @Excel(name = "入库日期", width = 15, format = "yyyy-MM-dd")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @ApiModelProperty(value = "入库日期")
    private Date expectedWarehousingTime;
    /**
     * 销售订单号  1
     */
    @Excel(name = "销售订单", width = 15)
    @ApiModelProperty(value = "销售订单")
    private String saleOrderNumber;
    /**
     * 销售订单行号   1
     */
    @Excel(name = "销售行项目", width = 15)
    @ApiModelProperty(value = "销售行项目")
    private String saleOrderLineNumber;
    @Excel(name = "产品类别")
    @ApiModelProperty(value = "产品类别")
    private String productType;
    @Excel(name = "产品型号", width = 15)
    @ApiModelProperty(value = "产品型号")
    private String productModel;
    /**
     * 客户编号    1
     */
    @Excel(name = "客户编号", width = 15, dictTable = "wms_basic_customer", dicText = "name", dicCode = "id")
//    @Dict(dictTable = "wms_basic_customer", dicText = "name", dicCode = "id")
    @ApiModelProperty(value = "客户编号")
    private String wmsBasicSupplierId;
    /**
     * 物料    1
     */
    @Excel(name = "物料", width = 15)
    @ApiModelProperty(value = "物料编码")
    private String materialCode;
    /**
     * 物料描述
     */
    @Excel(name = "物料描述", width = 15)
    @ApiModelProperty(value = "物料描述")
    private String materialName;
    /**
     * 物料描述
     */
    @Excel(name = "过账状态", width = 15)
    @ApiModelProperty(value = "过账状态")
    private String sapStatus;
}
